MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

40 rows where Object Name = 2727

View and edit SQL

Suggested facets: Is Public Domain, Title, Culture, Object Date, Object Begin Date, Object End Date, Credit Line, County, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
22492 60.107a, b 0 1 27397 Arms and Armor 5 Knife with sheath 2727 Imperial Knife with Sheath Chinese 10                           18th century 1701 1800 Steel, lapis lazuli, turquoise, pink stone, gold, enamel 5062 L. with sheath 11 1/4 in. (28.6 cm); L. without sheath 10 9/16 in. (26.8 cm); W. 15/16 in. (2.4 cm); Wt. 3.5 oz. (99.2 g); Wt. of sheath 4.9 oz. (138.9 g) Purchase, Rogers Fund, 1960                       Knives 49   Metropolitan Museum of Art, New York, NY 1
22863 36.25.850a, b 0 1 27829 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Philippine, Moro 526                           19th century 1801 1900 Steel, wood, copper, silver 5211 L. with sheath 13 1/8 in. (33.3 cm); L. without sheath 12 7/8 in. (32.7 cm); L. of blade 8 3/4 in. (22.2 cm); W. 1 7/8 in. (4.8 cm); Wt. 8.5 oz. (241 g); Wt. of sheath 3.2 oz. (90.7 g) Bequest of George C. Stone, 1935       Sulu 156               Daggers 33   Metropolitan Museum of Art, New York, NY 1
26006 36.25.1382a, b 0 1 31158 Arms and Armor 5 Knife with sheath 2727 Jungle Knife with Sheath Philippine, Yakan 911                           18th–19th century 1701 1900 Steel, wood, brass, cane (rattan) 6044 L. with sheath 25 1/2 in. (64.8 cm); L. without sheath 22 1/4 in. (56.5 cm); L. of blade 17 1/8 in. (43.5 cm); W. 2 in. (5.1 cm); Wt. 1 lb. 13.6 oz. (839.1 g); Wt. of sheath 10.9 oz. (309 g) Bequest of George C. Stone, 1935       Basilan 226               Knives 49   Metropolitan Museum of Art, New York, NY 1
26289 36.25.1045a, b 0 1 31441 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Hilt, Indian, Mughal; blade, Turkish 958                           Hilt, 18th century; blade, 19th century 1701 1900 Steel, jade, silver, emerald, ruby, gold 6188 H. with sheath 14 9/16 in. (37 cm); H. without sheath 13 3/8 in. (34 cm); H. of blade 7 1/2 in. (19.1 cm); W. 2 3/8 in. (6 cm); Wt. 7.3 oz. (207 g); Wt. of sheath 2.4 oz. (68 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26312 36.25.1068a, b 0 1 31464 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indonesian, Sulawesi (possibly Phillipine) 960                           18th–19th century 1701 1900 Wood, steel 3724 L. with sheath 9 in. (22.9 cm); L. without sheath 8 1/4 in. (21 cm); W. 3 3/16 in. (8.1 cm); Wt. 1.7 oz. (48.2 g); Wt. of sheath 1 oz. (28.3 g) Bequest of George C. Stone, 1935       Sulawesi 252               Knives 49   Metropolitan Museum of Art, New York, NY 1
26326 36.25.1085a, b 0 1 31478 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indonesian, Sulawesi, possibly Phillipine 962                           18th–19th century 1701 1900 Horn, steel 6211 L. with sheath 3 3/4 in. (9.5 cm); L. without sheath 3 5/8 in. (9.2 cm); W. 1 13/16 in. (4.6 cm); Wt. 0.4 oz. (11.3 g); Wt. of sheath 0.2 oz. (5.7 g) Bequest of George C. Stone, 1935       Sulawesi 252               Knives 49   Metropolitan Museum of Art, New York, NY 1
26327 36.25.1086a, b 0 1 31479 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indian, Mughal 312                           18th–19th century 1701 1900 Steel, jade, gold, ruby, gemstone, leather, silver 6212 H. with sheath 15 9/16 in. (39.5 cm); H. without sheath 13 15/16 in. (35.4 cm); W. 2 in. (5.1 cm); Wt. 8.8 oz. (249.5 g); Wt. of sheath 6.7 oz. (189.9 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26328 36.25.1087a, b 0 1 31480 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Turkish 68                           18th–19th century 1701 1900 Steel, agate, silver, leather, silk 6213 L. with sheath 12 in. (30.5 cm); L. without sheath 11 in. (27.9 cm); W. 13/16 in. (2.1 cm); Wt. 3.3 oz. (93.6 g); Wt. of sheath 1.7 oz. (48.2 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26329 36.25.1088a, b 0 1 31481 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Turkish 68                           19th century 1801 1900 Steel, jade, silver, velvet, wood 6214 L. with sheath 14 15/16 in. (37.9 cm); L. without sheath 12 1/2 in. (31.8 cm); W. 7/8 in. (2.2 cm); Wt. 4.8 oz. (136.1 g); Wt. of sheath 2.3 oz. (65.2 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26411 36.25.972a, b 0 1 31563 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Chinese 10                           18th–19th century 1701 1900 Steel, jade, gold, turquoise, coral, lapis lazuli 6251 L. with sheath 11 7/16 in. (29.1 cm); L. without sheath 9 13/16in. (24.9 cm); L. of blade 6 in. (15.2 cm); W. 13/16in. (2.1 cm); Wt. 3.2 oz. (90.7 g); Wt. of sheath 1.8 oz. (51 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26412 36.25.974a, b 0 1 31564 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath West Bornean, possibly Kalimantan Barat 976                           19th century 1801 1900 Silver, steel 314 L. with sheath 13 9/16 in. (34.4 cm); L. without sheath 10 9/16 in. (26.8 cm); W. 3 1/2 in. (8.9 cm); Wt. 5.4 oz. (153.1 g); Wt. of sheath 2.4 oz. (68 g) Bequest of George C. Stone, 1935   possibly Kalimantan Barat 645   Borneo 245               Knives 49   Metropolitan Museum of Art, New York, NY 1
26413 36.25.975a, b 0 1 31565 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Chinese 10                           18th–19th century 1701 1900 Steel, jade, shark skin, brass, gold 6252 L. with sheath 11 1/2 in. (29.2 cm); L. without sheath 10 3/4 in. (27.3 cm); W. 3/4 in. (1.9 cm); Wt. 2.6 oz. (73.7 g); Wt. of sheath 2 oz. (56.7 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26417 36.25.979a, b 0 1 31569 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Malayan 399                           18th–19th century 1701 1900 Gold, steel 3844 L. with sheath 13 1/4 in. (33.7 cm); L. without sheath 11 5/8 in. (29.5 cm); W. 1 in. (2.5 cm); Wt. 7.1 oz. (201.3 g); Wt. of sheath 4 oz. (113.4 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26419 36.25.981a, b 0 1 31571 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indian 67                           19th century 1801 1900 Steel, nephrite, brass 6256 L. with sheath 5 1/2 in. (14 cm); L. without sheath 4 7/8 in. (12.4 cm); W. 3/8 in. (1 cm); Wt. 0.7 oz. (19.8 g); Wt. of sheath 0.8 oz. (22.7 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26450 36.25.802a, b 0 1 31602 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Malayan 399                           18th–19th century 1701 1900 Wood, silver, steel, horn 6279 L. with sheath 12 15/16 in. (32.9 cm); L. without sheath 11 5/16 in. (28.7 cm); W. 2 1/2 in. (6.4 cm); Wt. 4 oz. (113.4 g); Wt. of sheath 1.8 oz. (51 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26455 36.25.807a, b 0 1 31607 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Chinese 10                           18th–19th century 1701 1900 Steel, brass, iron, wood, horn, bone 6281 H. with sheath 15 15/16 in. (40.5 cm); H. without sheath 12 3/4 in. (32.4 cm); H. of blade 6 1/2 in. (16.5 cm); W. 1 1/4 in. (3.2 cm); Wt. 5.3 oz. (150.3 g); Wt. of sheath 5.1 oz. (144.6 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26458 36.25.810a, b 0 1 31610 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Thai 606                           18th–19th century 1701 1900 Silver, steel 314 L. with sheath 16 7/8 in. (42.9 cm); L. without sheath 15 7/8 in. (40.3 cm); W. 1 3/8 in. (3.5 cm); Wt. 7.5 oz. (212.6 g); Wt. of sheath 3.5 oz. (99.2 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26484 36.25.843a, b 0 0 31636 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indian, Sikkim or Bhutanese 985                           18th–19th century 1701 1900 Steel, silver, wood 3505 L. with sheath 14 1/2 in. (36.8 cm); W. 1 5/8 in. (4.1 cm); Wt. with sheath 13 oz. (368.5 g) Bequest of George C. Stone, 1935       Sikkim 308               Knives 49   Metropolitan Museum of Art, New York, NY 1
26485 36.25.844a, b 0 1 31637 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indian, Sikkim or Bhutanese 985                           18th–19th century 1701 1900 Steel, silver, wood 3505 L. with sheath 15 in. (38.1 cm); L. without sheath 14 13/16 in. (37.6 cm); L. of blade 11 1/2 in. (29.2 cm); W. 1 3/4 in. (4.5 cm); Wt. 9.4 oz. (266.5 g); Wt. of sheath 3.7 oz. (104.9 g) Bequest of George C. Stone, 1935       Sikkim 308               Knives 49   Metropolitan Museum of Art, New York, NY 1
26487 36.25.846a, b 0 0 31639 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Malayan 399                           18th–19th century 1701 1900 Horn, wood, bone, silver 6297 L. with sheath 13 1/4 in. (33.7 cm); L. without sheath 10 1/2 in. (26.7 cm); L. of blade 6 1/2 in. (16.5 cm); W. 2 1/2 in. (6.4 cm); Wt. 2.5 oz. (70.9 g); Wt. of sheath 2 oz. (56.7 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26493 36.25.853a, b 0 0 31645 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indonesian, Sulawesi 771                           18th–19th century 1701 1900 Wood, horn 6005 L. with sheath 13 15/16 in. (35.4 cm); L. without sheath 13 1/4 in. (33.7 cm); L. of blade 10 in. (25.4 cm); W. 2 1/2 in. (6.4 cm); Wt. 4.3 oz. (121.9 g); Wt. of sheath 2.2 oz. (63.4 g) Bequest of George C. Stone, 1935       Sulawesi 252               Knives 49   Metropolitan Museum of Art, New York, NY 1
26498 36.25.858a, b 0 0 31650 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Malayan 399                           18th–19th century 1701 1900 Steel, horn, wood, bone 6300 L. with sheath 9 1/4 in. (23.5 cm); L. without sheath 6 3/8 in. (16.2 cm); L. of blade 3 3/4 in. (9.5 cm); W. 1 1/16 in. (2.7cm); Wt. 1.6 oz. (45.4 g); Wt. of sheath 1.1 oz. (31.2 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26505 36.25.865a, b 0 1 31657 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Malayan 399                           18th–19th century 1701 1900 Wood 25 L. with sheath 10 9/16 in. (26.8 cm); L. without sheath 10 1/4 in. (26 cm); L. of blade 7 1/2 in. (19 cm); W. 3 1/8 in. (7.9 cm); Wt. 3.2 oz. (90.7 g); Wt. of sheath 1.2 oz. (34 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26509 36.25.872a, b 0 1 31661 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Javanese 758                           16th–19th century 1501 1900 Metal 772 H. with sheath 12 1/16 in. (30.6 cm); H. without sheath 11 in. (27.9 cm); H. of blade 7 3/4 in. (19.6 cm); W. 2 1/4 in. (5.7 cm); Wt. 3.6 oz. (102.1 g); Wt. of sheath 1 oz. (28.3 g) Bequest of George C. Stone, 1935       Java 246               Knives 49   Metropolitan Museum of Art, New York, NY 1
26511 36.25.874a, b 0 1 31663 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indonesian, Sulawesi (possibly the Philippines) 986                           18th–19th century 1701 1900 Steel, horn 3986 L. with sheath 6 1/4 in. (15.9 cm); L. without sheath 5 1/2 in. (14 cm); W. 1 3/4 in. (4.5 cm); Wt. 0.8 oz. (22.7 g); Wt. of sheath 0.5 oz. (14.2 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26512 36.25.875a, b 0 1 31664 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Indonesian, Sulawesi (possibly the Philippines) 986                           18th–19th century 1701 1900 Horn, steel 6211 H. with sheath 6 5/8 in. (16.8 cm); H. without sheath 6 1/4 in. (15.9 cm); W. 2 1/16 in. (5.2 cm); Wt. 0.9 oz. (25.5 g); Wt. of sheath 0.6 oz. (17 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26513 36.25.876a, b 0 1 31665 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Sumatran 785                           18th–19th century 1701 1900 Wood, steel 3724 L. with sheath 9 11/16 in. (24.6 cm); L. without sheath 8 7/16 in. (21.4 cm); W. 2 in. (5.1 cm); Wt. 2.5 oz. (70.9 g); Wt. of sheath 1.3 oz. (36.9 g) Bequest of George C. Stone, 1935       Sumatra 214               Knives 49   Metropolitan Museum of Art, New York, NY 1
26515 36.25.878a, b 0 1 31667 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Javanese 758                           16th–19th century 1501 1900 Silver, iron 4251 H. with sheath 17 1/8 in. (43.5 cm); H. without sheath 15 3/8 in. (39.1 cm); W. 2 1/8 in. (5.4 cm); Wt. 10.8 oz. (306.2 g); Wt. of sheath 4.1 oz. (116.2 g) Bequest of George C. Stone, 1935       Java 246               Knives 49   Metropolitan Museum of Art, New York, NY 1
26521 36.25.886a, b 0 1 31673 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Javanese 758                           16th–19th century 1501 1900 Steel, wood 82 L. with sheath 9 15/16 in. (25.2 cm); L. without sheath 9 1/2 in. (24.1 cm); W. 2 3/4 in. (7 cm); Wt. 1.9 oz. (53.9 g); Wt. of sheath 0.6 oz. (17 g) Bequest of George C. Stone, 1935       Java 246               Knives 49   Metropolitan Museum of Art, New York, NY 1
26526 36.25.896a, b 0 0 31678 Arms and Armor 5 Knife with sheath 2727 Betel Nut Knife with Sheath Philippine, Moro 526                           18th–19th century 1701 1900 Steel, wood, bone, textile 6309 L. with sheath 8 1/4 in. (21 cm); L. without sheath 7 1/16 in. (17.9 cm); L. of blade 4 1/2 in. (11.4 cm); W. 1 1/2 in. (3.8 cm); Wt. 0.9 oz. (25.5 g); Wt. of sheath 0.7 oz. (19.8 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26530 36.25.701a, b 0 1 31682 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Malayan 399                           18th–19th century 1701 1900 Ivory, wood 820 L. with sheath 13 5/16 in. (33.8 cm); L. without sheath 12 11/16 in. (32.2 cm); L. of blade 9 1/2 in. (24.1 cm); W. 4 3/16 in. (10.6 cm); Wt. 7.2 oz. (204.1 g); Wt. of sheath 3.3 oz. (95.6 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26566 36.25.738a, b 0 1 31718 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Malayan 399                           18th–19th century 1701 1900 Silver 2 L. with sheath 17 3/8 in. (44.1 cm); L. without sheath 13 1/2 in. (34.3 cm); W. 1 7/8 in. (4.8 cm); Wt. 4.2 oz. (119.1 g); Wt. of sheath 5.7 oz. (161.6 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26587 36.25.759a, b 0 1 31739 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Turkish 68                           19th century 1801 1900 Steel, wood, silver, coral, brass 6335 H. with sheath 15 3/4 in. (40 cm); H. without sheath 12 1/2 in. (31.8 cm); W. 1 1/16 in. (2.7 cm); Wt. 5.4 oz. (153.1 g); Wt. of sheath 5.6 oz. (158.8 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26596 36.25.768a, b 0 1 31748 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Balkan, Turkish 1003                           18th–19th century 1701 1900 Steel, ivory, coral, brass, silver, wood, leather 6340 L. with sheath 14 in. (35.6 cm); L. without sheath 11 1/2 in. (29.2 cm); L. of blade 7 1/2 in. (19.1 cm); W. 1 1/2 in. (3.8 cm); Wt. 10.5 oz. (297.7 g); Wt. of sheath 3.4 oz. (96.4 g) Bequest of George C. Stone, 1935                       Daggers 33   Metropolitan Museum of Art, New York, NY 1
26608 36.25.780a, b 0 1 31760 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Moroccan, Mekus 1007                           19th century 1801 1900 Steel, wood, bone, brass 6154 H. with sheath 17 1/2 in. (44.5 cm); H. without sheath 17 1/4 in. (43.8 cm); H. of blade 12 in. (30.5 cm); W. 3 3/8 in. (8.6 cm); Wt. 7.9 oz. (224 g); Wt. of sheath 3.7 oz. (104.9 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26618 36.25.790a, b 0 1 31770 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Philippine, Moro 526                           18th–19th century 1701 1900 Steel, wood 82 H. with sheath 14 1/2 in. (36.8 cm); H. without sheath 12 3/4 in. (32.4 cm); W. 1 7/8 in. (4.8 cm); Wt. 5.6 oz. (158.8 g); Wt. of sheath 5.3 oz. (150.3 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26623 36.25.795a, b 0 1 31775 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Philippine, Bagobo 669                           18th–19th century 1701 1900 Steel, wood, cane (rattan) 5206 L. with sheath 21 in. (53.5 cm); L. without sheath 18 in. (45.7 cm); L. of blade 13 in. (33 cm); W. 2 3/4 in. (7 cm); Wt. 15.9 oz. (450.8 g); Wt. of sheath 6.2 oz. (175.8 g) Bequest of George C. Stone, 1935                       Knives 49   Metropolitan Museum of Art, New York, NY 1
26624 36.25.796a, b 0 1 31776 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath Philippine, Moro 526                           18th–19th century 1701 1900 Steel, wood, nickel, silver 6354 L. with sheath 19 3/8 in. (49.2 cm); L. without sheath 18 7/8 in. (47.9 cm); L. of blade 14.5 in. (36.8 cm); W. 2 3/4 in. (7 cm); Wt. 14 oz. (396.9 g); Wt. of sheath 5.4 oz. (153.1 g) Bequest of George C. Stone, 1935       Sulu 156               Knives 49   Metropolitan Museum of Art, New York, NY 1
26714 36.25.699a, b 0 0 31866 Arms and Armor 5 Knife with sheath 2727 Kinfe with Sheath Nias 996                           18th–19th century 1701 1900 Bone, wood 6412 L. with sheath 19 1/4 in. (48.9 cm); L. without sheath 17 3/8 in. (44.1 cm); L. of blade 14 in. (35.5 cm); W. 1 3/8 in. (3.5 cm); Wt. 6.9 oz. (195.6 g); Wt. of sheath 3.6 oz. (102.1 g) Bequest of George C. Stone, 1935       Sumatera Utara 283               Knives 49   Metropolitan Museum of Art, New York, NY 1
29929 17.190.300a, b 0 1 35169 Arms and Armor 5 Knife with sheath 2727 Knife with Sheath French, Dieppe 1238                           early 19th century 1800 1850 Steel, ivory, diamond, ruby, enamel, gold 7158 L. with sheath 9 1/4 in. (23.5 cm); L. without sheath 7 1/4 in. (18.4 cm); W. 1 in. (2.5 cm); Wt. 1 oz. (28.3 g); Wt. of sheath 2.2 oz. (62.4 g) Gift of J. Pierpont Morgan, 1917   Dieppe 689                   Knives 49   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 499.62ms · Data license: CC0 · Data source: metmuseum/openaccess